package com.liangxw.site.user.dao;

import com.liangxw.site.user.bean.User;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;

import java.util.List;

@Mapper
public interface UserMapper {
    @Select(value = "select * from bg_liangxw_user where id = #{id}")
    List<User> findUserList(@Param("id") String id);

    @Select(value = "select * from bg_liangxw_user where email=#{email}")
    User findUserByEmail(@Param("email") String email);

    @Select(value = "select * from bg_liangxw_user where telephone=#{telephone}")
    User findUserByTelephone(@Param("telephone") String telephone);

    @Select(value = "select * from bg_liangxw_user where username=#{username}")
    User findUserByUsername(String username);
}
